NTISthis.com

Evidence Guide: ICTDBS413 - Determine database requirements

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTDBS413 - Determine database requirements

What evidence can you provide to prove your understanding of each of the following citeria?

Determine the database size

  1. Determine the database scope from the user requirements
  2. Calculate the database size from the database scope and technical specifications.
  3. Document and justify the size and scope of the database
Determine the database scope from the user requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Calculate the database size from the database scope and technical specifications.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document and justify the size and scope of the database

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop the technical database requirements

  1. Design and document the data tables and relationships suitable to the user requirements and data sample
  2. Develop and document the data dictionary, table attributes and keys suitable to the user requirements
  3. Determine and document the database reports required by the user requirements and user acceptance criteria
Design and document the data tables and relationships suitable to the user requirements and data sample

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Develop and document the data dictionary, table attributes and keys suitable to the user requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine and document the database reports required by the user requirements and user acceptance criteria

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine security, performance, recovery and audit requirements

  1. Determine and document database security controls appropriate for the user requirements and the organisational data security plan
  2. Determine and document database performance, database recovery and database audit requirements to meet the user requirements and the organisational data security plan
Determine and document database security controls appropriate for the user requirements and the organisational data security plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine and document database performance, database recovery and database audit requirements to meet the user requirements and the organisational data security plan

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Seek client feedback and approval

  1. Evaluate and document database management systems against the database scope and size, technical database requirements, and security, performance, recovery and audit requirements to determine the appropriate option for the user
  2. Present database scope and size, technical database requirements, and security, performance, recovery and audit requirements documentation to the user for feedback
  3. Review user feedback and adjust the database documentation to meet the user acceptance criteria and user feedback
  4. Present database documentation to the user for final approval
Evaluate and document database management systems against the database scope and size, technical database requirements, and security, performance, recovery and audit requirements to determine the appropriate option for the user

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Present database scope and size, technical database requirements, and security, performance, recovery and audit requirements documentation to the user for feedback

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Review user feedback and adjust the database documentation to meet the user acceptance criteria and user feedback

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Present database documentation to the user for final approval

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Required Skills and Knowledge